home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Belgian Amiga Club - ADF Collection
/
BS1 part 60.zip
/
BS1 part 60
/
Prof. Calc d3.adf
/
Financial
/
5-Year Ratios.PCF
(
.txt
)
< prev
next >
Wrap
Gold Disk Spreadsheet
|
1991-12-11
|
14KB
|
154 lines
Gadgets and Widgets INC
$ Balance Sheet and Ratios
Current Assets
Cash
12000
30000
10000
55000
Accounts Receivable
35000
28000
25000
20000
Inventory
91000
102000
150000
100000
Raw Material
15000
17000
13000
10000
Work-In-Progress
Finished Goods
40000
50000
75000
49000
Total Current Assets
201000
233000
278000
243000
Fixed Assets
Land
Plant
355500
350500
330000
330000
Equipment
250000
240000
250000
284500
Total Fixed Assets
605500
590500
580000
614500
Total Assets:
806500
823500
858000
857500
Current Liabilities
Accounts Payable
17000
19000
21000
25000
Salaries Payable
10000
Taxes Payable
Short-term Loans
Total Liabilites
25000
28000
30500
41500
Long Term Debt
Term Loans
100000
100000
147500
100000
Bond Issues
SBA Loans
115000
112000
100000
100000
Total Long-term Debt
215000
212000
247500
200000
Net Worth
Preferred Stock
Common Stock
300000
300000
300000
300000
Retained Earnings
266500
283500
280000
316000
Total Net Worth
566500
583500
580000
616000
Liabilites + Equity
806500
823500
858000
857500
Revenues
Cost of Goods Sold
Gross Profit
----------
Rent
Depreciation
Utilities
General Expenses
Advertising
----------
Total Costs
Operating Profit
----------
Interest Expense
Taxable Profit
----------
Income Tax
After Tax Profit
Dividends
----------
Retained Earnings
RATIOS
Liquidity Ratios
Current Ratio
Quick Ratio
Average Collection Period
Day's Sales in Inventory
Leverage Ratio
Total Debt to Total Assets
Long-Term Debt to Equity
Times Interest Earned
UUUUUU
Asset Use Ratio
Sales to Inventory
______
ffffff
Sales to Working Capital
Sales to Total Assets
Sales to Fixed Assets
Profitability Ratios
Return on Assets
Return on Sales
Return on Net Worth